Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
|
|
The error occurred in C:/Web/PCL_NEW/NQF08/NQF_Narrative-new.cfm: line 73
|
71 : select top 1 isnull(tblmhahospitalnarratives.comments,'') as narrative,tblmhahospitalnarratives.updateddate from
72 : tblmhahospitalnarratives
73 : where fk_hospital_id = #ID# and fk_narrative_id in (#narrativeid#)
74 : </CFQUERY>
75 : <cfif #narrative.recordcount# gt 0>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
MHA |
VENDORERRORCODE |
156 |
SQL |
select top 1 isnull(tblmhahospitalnarratives.comments,'') as narrative,tblmhahospitalnarratives.updateddate from
tblmhahospitalnarratives
where fk_hospital_id = � and fk_narrative_id in (N)
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.147.103.234 |
Referrer |
|
Date/Time |
18-May-24 03:29 AM |
|